k="name" v="Avenue de Miremont"

SELECT * FROM way_tags WHERE k="name" and v = "Avenue de Miremont"
tag id key value Lien OSM
24704934nameAvenue de MiremontOSM
Retour